Education and Services Hub

Course Title:

Course ID:

060524 0601 1600ESH

Course Dates :

06/May/2024

 To

10/May/2024

Course Duration :

5

Course Location:

London

United Kingdom

Course Fees GBP £ :

Primary Price

£4,555.99

VAT may vary depending on the country where the course or workshop is held

Course Fees USD $:

Advisory Price

$5,829.09

VAT may vary depending on the country where the course or workshop is held

Course Category:

Computer Science Programmes

MS Excel, Soft Skills

Course Certified By:

* Professional Training and CPD Programs
* Executive Diploma Certificate
* Executive Masters Certificate

* ESHub CPD
* LondonUni
* Others

United Kingdom

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.

Course Information

Introduction

Welcome to the MS Excel Beginners Course!
This comprehensive five-day course is designed to equip participants with the fundamental skills needed to navigate and utilize Microsoft Excel effectively.
Whether you're a complete novice or looking to refresh your skills, this course will provide you with a solid foundation in Excel basics, enabling you to create, format, analyse, and manage data with confidence.
By the end of this course, you will have the confidence and proficiency to navigate Excel efficiently, perform basic data analysis, and create visually appealing spreadsheets to meet your personal or professional needs. We look forward to embarking on this learning journey with you!

Objectives

• Gain a thorough understanding of Excel's interface and basic functionalities.
• Learn essential techniques for data entry, manipulation, and formatting.
• Explore formulas and functions to perform calculations and automate tasks.
• Master data visualization tools to create impactful charts and graphs.
• Understand basic data analysis and sorting techniques.
• Develop proficiency in file management and collaboration using Excel.

Who Should Attend?

This course is ideal for:
• Individuals new to Microsoft Excel and looking to build a strong foundation.
• Professionals seeking to enhance their Excel skills for personal or professional development.
• Students or job seekers aiming to improve their employability by acquiring essential spreadsheet skills.
• Anyone interested in efficiently managing data and streamlining processes using Excel.

Training Method

• Pre-assessment
• Live group instruction
• Use of real-world examples, case studies and exercises
• Interactive participation and discussion
• Power point presentation, LCD and flip chart
• Group activities and tests
• Each participant receives a 7” Tablet containing a copy of the presentation, slides and handouts
• Post-assessment

Program Support

This program is supported by:
* Interactive discussions
* Role-play
* Case studies and highlight the techniques available to the participants.

Daily Agenda

The course agenda will be as follows:
• Technical Session 08.30-10.00 am
• Coffee Break 10.00-10.15 am
• Technical Session 10.15-12.15 noon
• Coffee Break 12.15-12.45 pm
• Technical Session 12.45-02.30 pm
• Course Ends 02.30 pm

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.

Week 1

Day 1:
Excel Basics and Navigation
• Introduction to Excel interface and terminology
• Navigating workbooks, worksheets, and cells
• Data entry techniques and best practices
• Basic formatting options for text and numbers
• Introduction to basic formulas and calculations

Day 2:
Formulas and Functions
• Understanding cell references
• Introduction to common functions (SUM, AVERAGE, MAX, MIN)
• Working with basic arithmetic functions
• Exploring logical functions (IF, AND, OR)
• Using functions for text manipulation

Day 3:
Data Management and Analysis
• Sorting and filtering data
• Introduction to data validation
• Working with tables for structured data management
• Introduction to conditional formatting
• Basic data analysis techniques (sorting, subtotaling)

Day 4:
Data Visualization
• Creating and formatting charts (pie, bar, column, line)
• Enhancing charts with titles, labels, and legends
• Using Sparklines for quick data analysis
• Introduction to PivotTables for dynamic data summarization
• Customizing charts and graphs for visual impact

Day 5:
Advanced Techniques and Final Projects
• Advanced formatting options (cell styles, themes)
• Introduction to macros for task automation
• Collaborative features in Excel (comments, sharing, tracking changes)
• Final project: Applying learned skills to solve real-world scenarios
• Course review and Q&A session

Please Note : Your £250.00 Deposit will be deducted from the total invoice Amount.
To commence the registration process for your training course, please follow the link provided and proceed with; Upon successful payment, we will promptly contact you to finalize your enrollment and issue a confirmation of your guaranteed placement.